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.
N400JSKing Canyon Buffalo Inc · Denver, CON400JWAirfleet Holdings LLC · Beverly Hills, CAN400KBArrowhead Circle Leasing LLC · Cedar City, UTN400LDreher Steve · Bettendorf, IAN400LBAutumn Crocus LLC · Cincinnati, OHN400LMGoldberg Gary S · Rockville, MDN400MAPetersen Jacob R · Wasilla, AKN400MJHaney Michael W · Tehachapi, CAN400NEKisska Michael K · Long Beach, CAN400RNGuirguis Samuel · Fort Myers, FLN400RUBell Jake T · Lexington, KYN400SDLeonard Tyler D · Newbury Park, CAN400TDHardy Mikel · Twin Falls, IDN400UBoard Of Regents Of The University Of Oklahoma · Norman, OKN400VVCarver Aero LLC · Muscatine, IAN400VWSpuza Dan D · Sanger, TXN400WHHorrigan William Jr · Roxbury, CTN400WRBrown Jon R · Palm City, FLN4010BEmerald City Aircraft Leasing Inc · Port Orchard, WAN4010ZDickey Livestock Inc · Mackay, IDN4011EFredericks Harry III Trustee · Woodland, CAN4011LSmith Jeffrey S · Linden, MIN4011MBush Pilot Inc · Soldotna, AKN4011PWelke Paul R · Beaver Island, MIN4011QKolb Michael J · Glenside, PAN4012FNational 967.LLC · Rock Hill, SCN4012MRhode Erik D · Farmington, MNN4012TStull Joshua S · Tacoma, WAN4012ZHronkin Jesse G · Palmer, AKN4013ERogers Twyla M · Windham, MEN4013MCook Richard J II · Princeton, ILN4013REquipment Plus LLC · Culpeper, VAN4013XN4013x LLC · Great Falls, MTN4014EMoriarty Gerald Joseph · Anchorage, AKN4014MWright James Henry · Brooksville, FLN4014PGriffing Flying Service Inc · Port Clinton, OHN4014XFournier Ronald A · San Diego, CAN4015NHazel Consulting LLC · Dayton, NVN4015TBauries Brian W · Abilene, TXN4016ZLong Island Soaring Assoc · Yaphank, NYN4017EJelinek Ed · Denton, MTN4017FHansen Drew A · Miami Springs, FLN4017MBryant Theodore M · Wasilla, AKN4017P17p LLC · Caddo Mills, TXN4017ZB4b Co · Ridgeview, SDN40189Jacob Mark K · East Lansing, MIN4018EWilliams Matthew S Trustee · Anchorage, AKN4018MCesare Anthony D · Millinocket, MEN4018TMalfaro William J · Boyertown, PAN4019XBoswell Joey L · Comanche, TX
Back to AD 90-04-06 R1