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.
N682AMBarclay Maclean F · Talkeetna, AKN682ASRegistration Pending · Stony Brook, NYRegistration pendingN682ATTexas Flight Training Aircraft 8 LLC · Wilmington, DEN682CPCivil Air Patrol · Maxwell Afb, ALN682DCSteele Aviation Inc · Walnut Cove, NCN682FGlobal Flight Training Solutions Inc · Immokalee, FLN682JAYale Companies LLC DBA · Indianapolis, INN682LHChristiansen Aviation LLC · Wilmington, DEN682MAChristiansen Aviation LLC · Wilmington, DEN682PBoard Of Trustees Of Southern Illinois University · Carbondale, ILN682RByrd Cattle Co Inc · Canyon, TXN682SAWings Over Texas Holdings LLC · Denton, TXN682SBSundowners Inc · Fort Myers, FLN682SPHansell Stephen E · East Windsor, NJN682TFAir Fleet Holdings LLC · Addison, TXN682TXHartman Joshua Albert · Andover, KSN68302Fulltron Aviation LLC · Springfield, MON6830EJackson Thomas M · Florissant, MON6830PGregory M Gabriela · Las Vegas, NVN6830UJilek Dominic A · River Falls, WIN6831HQuarry Jon C · Memphis, TNN6831KAbbott Cedric M · Buckfield, MEN6831VMirage Partners LLC · Biddle, MTN68323Briggs Jeffery M Trustee · Royal Oak, MIN68329Ace Aircraft Leasing Inc · Nazareth, PAN6832FJpf Ventures LLC · Owatonna, MNN6832JHolseberg Properties LLC · Ridgeville, SCN6832PDrag Walter J · Longs, SCN6832ULanetti Leonard J · Malvern, PAN6832VCrawford Sharri R · Rio Rancho, NMN6832WLitchfield Bobby Lee · Claremont, CAN68332Wings Over Texas Holdings LLC · Denton, TXN68334University Of Michigan Flyers · Ann Arbor, MIN6833BBlatchford Devin M · Arkansas City, KSN6833CTexins Flying Club · Mckinney, TXN6833FPatriot Aviation LLC · Huntington, INN6833JHumphries Aviation LLC · Maysville, KYN6833PHolmes Darrell · Chino Hills, CAN68342M & S Air Supply Inc DBA · Hawthorne, CAN68344South Bay International Flight Association Inc · Torrance, CAN68348Tully Robert · Eighty Four, PAN68349East Derrick A · Cullman, ALN6834KKilbourned Garrot · Liberal, KSN6834NSiebold David J · Painesville, OHN6834UFlydog Aviation LLC · East Grand Forks, MNN6834VDavis James D · Hamilton, MTFirst renewal noticeN6834WFlores Lindenfelser Armando · Apache Junction, AZN68356Don Davis Aviation Inc · Henderson, KYN6835HIowa Lakes Community College · Estherville, IAN6835JPronk Glen R · Crittenden, KY
Back to AD 81-18-04 R2