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.
N6264LLunnie Leisha N · Thompson, NDN6264ZSimmons Aviation Services LLC · Pawcatuck, CTN6265ALewis Albert D · Newark, OHN6265DCommander Funk Llp · Portland, ORN6265ZAerial Banners Inc · Pembroke Pines, FLN62660Steele Timothy W · Hancock, NHN62669Eckelman Keith R · Culver, ORN6266AGhaemi Mike · West Hills, CAN6266VSix Pack Aviation LLC · Pocono Pines, PAN6266ZLinzel Jesse Gray Jr · Southern Pines, NCN6267ZGordon Strom B Jr · Paris, TXN62689Optic Air LLC · Sioux Center, IAN6268DSafety In Motion Flight Center Inc · Puyallup, WAN6268JGaal Stephen E · O Neals, CAN6268LMcmillin James · Charlotte, NCN6268UBlair Management Holdings LLC · Carefree, AZN6268WTereshchenkov Nikita · Edgewood, WAN6268ZKnutson Wayne R · Tioga, NDN62690Aerosim Academy Inc · Sanford, FLN62694American Patrols Inc · Midland, TXN6269CBorck Benjamin · Bala Cynwyd, PAN6269DCongressional Flying Club Inc · Gaithersburg, MDN6269LScotty Express LLC · Gilbert, AZN6269UKetola Keith C · Seaside, CAN626AFCape Fear Pilots LLC · Bald Head Island, NCN626ALLutes Richard · Hampshire, ILN626APDobry Robert S · Crescent City, FLN626BCherokee Family Limited Partnership · Watsonville, CAN626BAScott Barry R · Florence, ALN626BCCronin Robert B Jr · Candia, NHN626BPBroburg Gregory W · Minneapolis, MNN626CPPenn Flight Academy LLC · Quakertown, PAN626DCFlying For Conservation LLC · Juda, WIN626DDMueller Ryan S · Houston, TXN626DGGoodrich Donald A · Webster, MNN626DWWings Of Freedom LLC · Big Bear Lake, CAN626FFKnapp Edward · Zephyrhills, FLN626FT626ft LLC · Los Angeles, CAN626JAFlyingrns LLC · Kalispell, MTN626JTTower John A · Albion, NYN626KPSchultz Kenneth L · Mohave Valley, AZN626LDAerofleet LLC · Oldsmar, FLN626LHHeli-Tech Inc · Panama City, FLFirst renewal noticeN626MDaigle Christopher C · Crowley, LAN626MJGreathouse Nicholas Lee · Casa Grande, AZN626NJCohesive Aviation LLC · Gilford, NHN626NRJones Robert D · Chestertown, MDN626PABird Acquisition LLC · Phoenix, AZN626PMMckivergan Michael · Yuma, AZN626RCMurray Coy L · Guntersville, AL
Back to AD 90-04-06 R1