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.
N711HYTegeler Walter S · Westminster, MDN711JJReady Aim Flyer LLC · New Castle, DEN711KKRegistered aircraftN711KNLowe Kevin · Martinsville, INN711LPJohnson Tommy A · Grand Junction, CON711NDFlight Leasing Corp · Wilmington, DEN711PKKramer Peter W · Copper Center, AKN711PTTaylor Stephen N · Punta Gorda, FLN711QSaddlemire Joshua S · Lake Arrowhead, CAN711RNGoldsmith Donald E Jr · Brandywine, MDN711RVNicholson Kameran · Fowler, KSN711SGGullo Santo · Ponce Inlet, FLN711SHHighley Robert W Jr · Lakeland, FLN711TSStarr William E · Eagle River, AKN711UATuthill Andrew M · Etna, NHN711WBNewberg Edgar T · Hector, MNN711WEMelbourne Flight Training LLC · Melbourne, FLN711XCFore Shannon Richard · Wasilla, AKN711YAStegmann Scott A · Port Orange, FLN711YCIturriria John M · Kuna, IDFirst renewal noticeN711ZHappenstance LLC · Cabot, ARN712Oman Lee · Sequim, WAN7120DWeiss James R · Westlake, OHN7120GSky Hook Inc · Red Wing, MNN7120LTschirhart Larry S · San Antonio, TXN7120QClodfelter Terry Lynn · Norwood, NCN7120VOpulent Investments LLC · Mandan, NDN7120YRoyal Ryan M · Lincoln, NEN7121DBohrman Robert C · New Berlin, WIN7121PLecren Douglas · Wasilla, AKN7121YUhlemeyer William A · Alvin, TXN7122AContinental Helicopters Inc · Sheffield, TXN7122BCgu Aviation LLC · Naples, FLN7122EChristiansen Aviation LLC · Wilmington, DEN7122GBirmingham Flight Center LLC · Birmingham, ALN7122KMacleod Gary G · Valentine, NEN7122RSimmons Heating And Air Conditioning LLC · Summerville, SCN7122VProvance Brent L · Granbury, TXN7122YSutton Jack M · Jesup, GAN7123GJet & Rotor Aviation LLC · Sacramento, CAN7123UMatherly Frank · Greenbrier, TNN7123WHarvick Wayne P II · Kenmore, WAN7124KBlackburn Douglas W · Auke Bay, AKN7124LTriad Management Group LLC · Papillion, NEN7124QVy Aviation LLC · Gentry, ARN7124RNewsome Thomas D · Canal Winchester, OHN7124UGoss Brendan · Shady Shores, TXN7124VHunter Cameron Brooks · Keller, TXN7124WTuchols John E · Lockport, NYN7125GBohannan Joshua S · Rose Hill, KSFirst renewal notice
Back to AD 90-04-06 R1