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.
N675LHFf22 LLC · Scottsdale, AZN675MMDeane Steve P · Arlington, TXN675QFisher Global LLC · Conway, ARN675RFGoodson Danny R · Bristol, VAN67601Aero Maintenance Inc · Vancouver, WAN6760BAnderson Michael N · Anchorage, AKN6760WBitter Loren Mark · Maricopa, AZN67611Kumor Ronald G · Casper, WYN67614Wampus Cats Inc · Davenport, IAN67617Bohon Todd R · Palmer, AKFirst renewal noticeN67618Hale Douglas W · Perryton, TXN6761UJaeger Howard E · Claremore, OKN6761WGirdley James Kevin · Taylorsville, KYN67624Hardman Lorin D · Wasilla, AKN6762BCarver Clarence K Trustee · Lutz, FLN6762NTaylor Norman A · Fayette, ALN6762WFox John M · Warrenville, ILN67638Blue Feathers Corp · Newark, DEN6763JMiddlestetter Matthew G · Green Cove Springs, FLN6763NRegistration Pending · Minden, NVRegistration pending, pending cancellationN6763PHeublein Eric C · Molalla, ORN67648Flying Vikings Inc · Hayward, CAN6764BMccollum Glen R Jr · Nikiski, AKN6764JZalik Michael A · San Francisco, CAN6764NBiermann William W · Hollister, CAN67651Salomonsson Mats · Fremont, CAN67652Final Design Group LLC · Hurricane, UTN67657Jade Air LLC · San Pedro, CAN6765NBogdan Joseph H · Soper, OKN6765WKakoczki Robert J · White Cloud, MIN6766BRutland Norman L Jr · Birmingham, ALN6766NFoley Erik J · Henderson, NVN6767BHolseberg Aviation LLC · Ridgeville, SCN6767CSilverstein Devyn · Austin, TXN6767JLarson Wayne K · Amboy, CAN6767NEichhorn Tyler L · Paonia, CON6767VParmenter Micah J · Aurora, CON6768BKimmel Frank Stewart III · Greenwood, MSN6768FFallis Robert P · Keller, TXN6768JSuncoast Flight Training LLC · Sarasota, FLN6768NPorthouse Chris · Bellingham, MAN6768PKeenan John E · Saratoga, CAN6768UBranson Randel L · Eclectic, ALN6768WCimeira Aviation LLC · Birmingham, ALN6769JHanson Tobin S · Westlake, ORN6769NCausey Kevin L · Bainbridge, GAN6769PKroll Richard L · Montague, MIN6769UWard Leonard · Preston, IDN676APiper Archer Three LLC · Wilmington, DEN676AKDillard Clayton B · Talkeetna, AK
Back to AD 90-04-06 R1