AD 87-10-06 R1
Registered aircraft · 72,010
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:87-10-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:87-10-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:87-10-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:87-10-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.
N6265ZAerial Banners Inc · Pembroke Pines, FLN62660Steele Timothy W · Hancock, NHN62665Murvin Theoren J III · Winter Garden, FLN6266VSix Pack Aviation LLC · Pocono Pines, PAN6266ZLinzel Jesse Gray Jr · Southern Pines, NCN62677Kersey Brian A · Pulaski, TNN6267BRosario Angela · San Juan, PRN6267HNorthern Wings Aviation LLC · Bozeman, MTN6267KMill Boys Flying LLC · Wilmington, DEN6267PFlyhigh LLC · Midlothian, VAN6267ZGordon Strom B Jr · Paris, TXN62688Blair Leonard · Fleetwood, PAN62689Optic Air LLC · Sioux Center, IAN6268DSafety In Motion Flight Center Inc · Puyallup, WAN6268JGaal Stephen E · O Neals, CAN6268UBlair Management Holdings LLC · Carefree, AZN6268WTereshchenkov Nikita · Edgewood, WAN6268ZKnutson Wayne R · Tioga, NDN62690Aerosim Academy Inc · Sanford, FLN62694American Patrols Inc · Midland, TXN62697Edwards Benjamin F · La Canada, CAN62699Antelope Valley College · Lancaster, CAN6269CBorck Benjamin · Bala Cynwyd, PAN6269DCongressional Flying Club Inc · Gaithersburg, MDN6269MSears James W Jr · Kotzebue, AKN6269TN6269t · Lampe, MON6269UKetola Keith C · Seaside, CAN6269YN6269y Six Place LLC · Miami, FLN626AFCape 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, NHN626BFVenture North Aviation LLC · Cloquet, MNN626BPBroburg Gregory W · Minneapolis, MNN626CPPenn Flight Academy LLC · Quakertown, PAN626CWMassey Edward Rush · Union, MSN626DBJims Air LLC · Oconomowoc, WIN626DCFlying 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, NYN626LSHollendonner Keith · Markleville, INN626MJGreathouse Nicholas Lee · Casa Grande, AZN626NJCohesive Aviation LLC · Gilford, NH
Back to AD 87-10-06 R1