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.
N65DRKlr Services LLC · Newalla, OKN65ECMartinez Fernando · Midland, TXN65EDConrad James J · Port Orange, FLN65EEEssler Kim L · Garrison, NDN65EJRobbins Lesley Linn · Bend, ORN65ELSutton Edwin · St Thomas, VIN65ESShaw Ellen M · Green Bay, WIN65FVVyfvinkel Frederick J · New Smyrna Beach, FLN65GSchmitt Joseph P · Marshall, MON65GGRegistered aircraftN65GLDavidson Amber M · Cocoa, FLN65HRSt Squared LLC · Powell Butte, ORN65HTRoberts Bryan J · Norman, OKN65JAJahawk Leasing LLC · Sugar Grove, ILN65JSCall One Inc · Clarinda, IAN65JXFlight World Inc · San Juan, PRN65KDNorthwest Wings LLC · Hillsboro, ORN65KFCrestwood Aviation LLC · Schererville, INN65KKExperimental N65kk LLC · Little Rock, ARN65MMShewbart Keith M · Crystal River, FLN65NPWilson Stuart L · Glenpool, OKN65NURanard Douglas R · Dugger, INN65PHMuetzel Michael P · New Port Richey, FLN65PPAir-Supply Aerial · Philomath, ORN65PTBs Aviation LLC · Portland, ORN65RJAdvantage Flight Training And Services LLC · Warren, ARN65RWPhoenix 65rw LLC · Fayetteville, GAN65SAAkin & Son Inc · Texarkana, TXN65SDBlankenship Royce J · Daytona Beach, FLN65SGMacdonald Gerald C · Oberlin, OHN65TXMitchell David Lamar · Ashdown, ARN65WAWoolse Duane L · Salt Lake City, UTN65WMWilson Thomas L · Texarkana, TXN65WYCoyle Jerry Lee · Prairie Grove, ARN65XXWeidenbaum James M · Boerne, TXN65ZMReinschmidt John S · Lakeway, TXN6600PParker Matthew M · Mesa, AZN6600RDoyles Welding Lc · Phillipsburg, KSN66015Rock Solid Aviation LLC · Lake Charles, LAN66018Executive Aviation LLC · Peoria, AZN6601HCanby Pilots Club Inc · Canby, MNN6601JRobinson John H · Kernersville, NCN6601KAir Force Academy Aero Club · Usaf Academy, CON6601RHolmes Donald R · Carlsbad, CAN6601WAircraft Guaranty Corp Trustee · Oklahoma City, OKN66023Bravo Aero LLC · Concord, NCN6602DLand Of Liberty LLC · Seminole, FLN6602ERivera Joel · Carolina, PRN6602HOver The Mountain Aviation LLC · Calera, ALN6602JD14 Flight Club Inc · Manteno, IL
Back to AD 90-04-06 R1