AD 81-18-04 R2
Registered aircraft · 81,733
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:81-18-04-R2')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2')
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:81-18-04-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2') 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.
N62660Steele Timothy W · Hancock, NHN62669Eckelman Keith R · Culver, ORN6266AGhaemi Mike · West Hills, CAN6266VSix Pack Aviation LLC · Pocono Pines, PAN6266ZLinzel Jesse Gray Jr · Southern Pines, NCN6267BRosario Angela · San Juan, PRN6267HNorthern Wings Aviation LLC · Bozeman, MTN6267PFlyhigh LLC · Midlothian, VAN6267ZGordon 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, AZN6269MSears James W Jr · Kotzebue, AKN6269QMustang Sally Aviation LLC · Camden, SCN6269TN6269t · Lampe, MON6269UKetola Keith C · Seaside, CAN626AAWings Over Texas Holdings LLC · Denton, TXN626AFCape 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, MNN626CBWings Over Texas Holdings LLC · Denton, TXN626CPPenn Flight Academy LLC · Quakertown, PAN626CWMassey Edward Rush · Union, MSN626DCFlying For Conservation LLC · Juda, WIN626DDMueller Ryan S · Houston, TXN626DGGoodrich Donald A · Webster, MNN626DWWings Of Freedom LLC · Big Bear Lake, CAN626EPEpic Aviation Inc · Denison, TXN626FFKnapp Edward · Zephyrhills, FLN626FT626ft LLC · Los Angeles, CAN626GMMike Smith Aviation International Inc · Napa, 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, LA
Back to AD 81-18-04 R2