AD 64-06-06
Registered aircraft · 4,740
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:64-06-06')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:64-06-06')
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:64-06-06') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:64-06-06') 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.
N1284NAbnc Air LLC · Wellington, FLN1286THeffelfinger Paul D · Seven Valleys, PAN1295TLutz Brian · Carmel, INN1318TAire-Drifter LLC · Staten Island, NYN1326TNelson Raul · Annapolis, MDN1332TSchwartz Matthew M · Royal Oak, MIFirst renewal noticeN1346TNortham Thaddeus R · Mckinney, TXN1347THagan William Jackson · Wetumpka, ALN1353YRust Joyce A · Bourbon, INN1359TNahir Ehud · Woodland Hills, CAN1379TGordon William E · Summit, NJN1388TNora Jet LLC · Granbury, TXN1389TR And S Flying LLC · Westfield, MAN139SNMccullough Jacob D · Lockhart, TXN13KFRockwood Blake T · Fort Worth, TXN13KRKaplan Ronald · Palm Beach Gardens, FLN13RGIsland Piper Llp · St Helena Is, SCN1407XRavotti Air LLC · Leechburg, PAN140WMBlue Wings LLC · Rossville, TNN1418TZucchi Steven · Ephrata, PAN1428JLeedham James E DBA · Mazeppa, MNN1432TSmith David · Belleville, ILN143BSMoses Charles · West Friendship, MDN1442TKeller Mark · Alexandria, KYN1448XMallett Robert T · Wilmington, MAN1450TBruce James E · Prattville, ALN1454XPetrak Richard A · Hunker, PAN1464TSiedentopf Zyurelaie Indiana · Yelm, WAN1465HHolland Ray A · Blue Earth, MNN1467TThree2tango LLC · Mount Pleasant, SCN1477TSrh Club Inc · Wilmington, DEN1484XAlpha-One Air Service LLC · Concord, NCN1487TFalcon Flying Club LLC · Fayetteville, GAN1490XTwin Peaks Holdings · Midvale, UTN1491TGreat Lakes Air Ventures LLC · Mason, MIN149DCDale Gared W · Hugo, OKN14DP5b Aviation LLC · Duncan, OKN14RWJohnston Jeffrey T · Ramsey, MNN15002Registered aircraftN15005Oliver Everett G · No Mankato, MNN1501XBowser William K · Ball Ground, GAN1507TAero Care Inc · Orange, MAN15101Blackwater Air LLC · Pace, FLN15106Chew Terrence G · Allyn, WAN15107Skahen Sean M · Saint Joseph, MNN15115Price Michael D · Shell Knob, MON15123Blackwood Aviation Services Inc · Orlando, FLN1513XTurner Gary H · Big Stone Gap, VAN15141Murphy Jeffrey S · Mechanicsburg, PAN15142Dj Aviation LLC · Rio Vista, TX
Back to AD 64-06-06