AD 81-18-04 R2
Registered aircraft · 81,733
Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.
Query with SQL
duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2')
ORDER BY n_number"Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2') ORDER BY n_number
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
N819JSZnamenacek Kevin L · Western, NEN819KKochman Robert W · Kirkland, WAN819KSN819ks LLC · Palm City, FLN819MWPussy Galore Aviation LLC · Kalispell, MTN819PASkywest Leasing Inc · St George, UTN819PRHernandez Galin · Saint Augustine, FLN819RTLeatherwood Michael W · Granbury, TXN819SBCarroll Justin · Harrisburg, NCN819SMAnderson George M · Hattiesburg, MSN819TTHillsboro Aero Academy LLC · Hillsboro, ORN819VKRosiere Jason Daniel · Haslet, TXN819WWMaier Ryan D · Bemidji, MNN819YKBoswell Jeffrey · Kingsland, GAN81AKAdk Global LLC · Hollywood, FLExpired dealer, pending cancellationN81ARTredway Robert J · Prescott, AZN81AVShyan Inc · Thomasville, NCN81BAAscent Aviation Inc · Van Nuys, CAN81BHPalmer Robert E · Cedar Key, FLN81BJBudahn Christopher W · Kenyon, MNN81BSFairchild Donald R · Ringgold, GAN81CAColeman Aeroclub · Apo, AEN81CYKrueger Nicholas P · Somerset, WIN81DStephen Jones · Roach, MON81DEElder Dennis R · Cookson, OKN81DGRae Seth R · Spotsylvania, VAN81DHMusser Scott S · Pasco, WAN81DNWaite John B · Tacoma, WAN81DSMarathon Leasing Inc · Elyria, OHN81ECWalker Robert · Chula Vista, CAN81EJSouthern Aircraft Consultancy Inc Trustee · Casper, WYN81EMMalone Mark R · League City, TXN81ESBranciforte Louis N · Watsonville, CAN81FBStack John A · Trenton, SCN81FFPeregrine Howard Partners II Lp · New Orleans, LAN81GTCamgo LLC · Kenosha, WIN81GWWolfe Ian Sean · Spring Branch, TXN81HFGray Eugene F · North Hampton, NHN81HSHarris David C · Ventura, CAN81HYAviat Aircraft Inc · Afton, WYN81JACsukay Orkideh · Reseda, CAN81JDBarbour Grays Inc DBA · Buckhannon, WVFirst renewal noticeN81JFMains Donald L · Hiram, MEN81JGGreaves Jr John P · Redding, CAN81JRPlane Fun Inc Tr Trustee · Snellville, GAN81JVVoss James S · Boulder, CON81KSChristiansen Aviation LLC · Wilmington, DEN81LBGaravaglia Gary E · Statesville, NCN81LCBynum Leo M · Albuquerque, NMN81LERieger Mark W · Woodland, CAN81LKKinder Larry R · Fort Myers, FL
Back to AD 81-18-04 R2