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.
N4338PTroy Oakland Pilots Flying Club Inc · Troy, MIN4338QRegistration Pending · Salisbury, NCRegistration pendingN4338RThompson Group Inc · Stockton, CAN4338TBenham Properties LLC · Sullivan, INN4338VFlying Mermaid LLC · Aiea, HIN4338ZJwg Aviation LLC · Livingston, MTN43394Skyline Solutions Inc · Deland, FLN4339DSterk Ashton D · Lees Summit, MON4339HKaufman Timothy H Trustee · Saint Charles, MIN4339MLazor Ronald E · Middlefield, CTN4339QC & K Aero LLC · La Valle, WIN4339RBurke Brian · Westlake, OHN433AGRinehart Orville J · Forest Lake, MNN433CBTeam Cb LLC · Missoula, MTN433DPPitzer Douglas A · Corona, CAN433FLTrue North Aviation LLC · Cooperstown, NDN433FRKtoa Rentals LLC · Torrance, CAN433FSPontoni Michael E · Newnan, GAN433JDRittenhouse John D · Costa Mesa, CAN433MASkywest Leasing Inc · St George, UTN433PABird Acquisition LLC · Phoenix, AZN433PCRoush Russel A Trustee · Gillette, WYN433PTPilot Training Center LLC · Miami, FLN433RAHudson Allen D · Rio Grande, OHN433RMRocky Mountain College · Billings, MTN433TJKennedy John A · Marietta, GAN433VBPalumbo Christopher · San Antonio, TXN433WKingdom Air Corps · Sutton, AKN433WWFleming Judith A · Murrieta, CAN43408Miloud Chadd K · Fort Worth, TXN4340HEiden Ryan J · Central, AKN4340MMiller William M · Brenham, TXN4340ZBrown Helicopter Inc · Pensacola, FLN43419Grogan II Jerrald V · Prairie City, IAN4341HGunstream Jesse B III · League City, TXN4341JSundstrom Steven · Reno, NVN4341PToribio LLC · San Antonio, TXN4341ROleary Paul V · Gold Creek, MTN4341TSmith Theodore D · Palm Bay, FLN4341WBarlow Steven J · Mansfield, OHN4341ZMeans Loren Alonzo III · Wasilla, AKN43422Weaver Erik J · Roseburg, ORN4342CTwin City Air Activities Inc · Rock Falls, ILN4342EMoon Jonathan Edward · Butler, PAN4342MStout Lloyd J · Belmont, CAN4342XAlpha Aviation Inc · Mount Vernon, WAN4342ZCook Raymond L · Spring Grove, ILN43431Upchurch James Stephen · Rockfield, KYN43434Bg Partners LLC · El Cerrito, CAN4343QK M Air Enterprises Inc · Corona, CA
Back to AD 90-04-06 R1