AD 90-04-06 R1
Registered aircraft · 68,377
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:90-04-06-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:90-04-06-R1')
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:90-04-06-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:90-04-06-R1') 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.
N827FJMiller Andrew W · Palmer, AKN827GBJohnson Douglas C · North Grafton, MAN827GLEtchart Joseph O · Glasgow, MTN827GSFosha Kathryn · Tehachapi, CAN827JHEisenmenger James P Trustee · Yankton, SDN827JPHuls James J · Madison, SDN827KSPlanelease LLC · Venice, CAN827MAPs N827ma LLC · Green Bay, WIN827NDUnd Aerospace Foundation · Grand Forks, NDN827PAkin Thomas A · Visalia, CAN827PMMagnuson Peter C · Ocala, FLN827VPClik Services LLC · Forestdale, MAN827WTCsu Aviation LLC · Plainfield, INN8280NEllis Clifford J · Murray, KYN8280WGarbin Kurt A · Steamboat Springs, CON8281CThomas Ken C · Fairbanks, AKN8281EAir Plains Services Corp · Wellington, KSN8281GWidtfeldt John R · Auburn, PAN8281JJudy Gregory K · Hudson Oaks, TXN8281NTan Dexter E · Dallas, TXN8281WNeisen Brandon L · Fowler, ILN8282JHoover Michael B · Ridgeland, WIN8282VEnsemble Air LLC · Laramie, WYN8282WBenker Albert J · Bevier, MON82832Stokke Todd · Magnolia, TXN82836Aerodreams Aviation LLC · Raleigh, NCN8283JFurey Gale J · Bedford, NHN8283NRuth Joyce Aviation LLC · Henderson, TXN8283VMiloud Chadd K · Fort Worth, TXN8283YPhillips Thaddus L · Knoxville, TNN8284JCrouch Scott M · Steamboat Springs, CON8284NHolland Alan L · Houston, TXN8284WCaldwell Darrel R · Panama City Beach, FLN82859Schoeler George A · Ocala, FLN8285BHyldburg Aviation Inc · Plymouth, MAN8285EJames G Loy General Contractor Inc · Punta Gorda, FLN8285WBas Part Sales LLC · Greeley, CON8285YAmerican Aviation Inc · Woods Cross, UTFirst renewal noticeN82864Meyer Fredric Kim · Orange, CAN8286CMidwest Sky Chasers Nfp · Algonquin, ILN8286EPreston Richard R Trustee · Albuquerque, NMN8286NAyyildiz Erol · Glen Rock, NJN8286RHuhnke John F · Newburgh, INN8286YCoub Industries Inc · Fairfield, CAN8287Holloway Earnie G · Bonner Springs, KSN8287BCostanti Nicolas J · Medford, ORN8287JBurnett Stephen B · Granby, MON8287NBetik Patrick G · Grapevine, TXN8288AJohnson Carmen · White Cloud, MIN8288CRood James D · Winston, NM
Back to AD 90-04-06 R1