AD 2002-26-01
Registered aircraft · 29,517
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:2002-26-01')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-26-01')
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:2002-26-01') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-26-01') 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.
N104GDFiebiger Mark D · Leesburg, FLN104GKIndigo Bunting Aviation LLC · Morristown, NJN104GRMargolis David · Tucson, AZN104HPGenesis Aviation Enterprises Inc · Fort Lauderdale, FLN104JASkywest Leasing Inc · Saint George, UTN104JBF2 Aviation & Marine Assets LLC · Solana Beach, CAN104JGRoscioli Lamberto · Lighthouse Point, FLN104JWGobeli Michael T · East Lyme, CTN104KGKing & Co LLC · Arroyo Grande, CAN104LDMasys Daniel R · Lincoln, CAN104LJFeldhousen Larry A · Burlington, CON104LULynn University Inc · Boca Raton, FLN104MEMathis Mark D · Richmond, TXFirst renewal noticeN104MFEccker Donald E · Ramona, CAN104MJLift Drag Aviation LLC · El Cajon, CAN104MQL C Whitford Co Inc · Wellsville, NYN104MRMccurdy Mark L · Tucson, AZN104MXFrancis Scott P · Montclair, VAN104NRainey Norman W · Surprise, AZN104PKKreuter Paul E · Goshen, INN104PSDepartment Of The Interior · Boise, IDN104RGWeiss Elliott · Fresno, TXN104SJLockard John D · Oceanside, CAN104TMRegistration Pending · Lenoir, NCRegistration pendingN104TTTucker Thaddeus D · Wilder, IDN104USHartenstine Michael C · Lancaster, CAN104WHGreycal Enteprrises Inc · Lake Mary, FLN104XPRv X Aviation LLC · Draper, UTN104ZURuttler James J · Bremerton, WAN1050BNine1on Industries LLC · Helena, MTN1050QCouch Kelly P · Elk Grove, CAN1051EHartman William · Imperial, MON1051ZDranttel Timothy John · Fuquay Varina, NCN1053BLoveland Inc · Vance, MSN1053WPcxii LLC · Greensburg, INN1053XChristiansen Aviation LLC · Wilmington, DEN1054QTaylor Hauling II LLC · Laurel, MSN1054TInternational Air Services Inc Trustee · Carson City, NVN1054UDippolito Thaddeus M · Sherwood, ARFirst renewal noticeN10555Mccrea Daniel B · Waldport, ORN1056JPowell John F · Sunnyvale, CAN1056LFahey Christopher S · Denton, MDN1057JMccann Air Corp · Wilmington, DEN1057QLofty Goals Aviation LLC · Liberty Lake, WAN1057RAnesthesia Aviation LLC · Leesburg, VAN1057TMclane Trailer Sales Inc · Poplar Bluff, MON1057ZAcc Transport LLC · Pomona, CAN1058JMoon Valley Aviation LLC · Ozark, MON1058LArnote Jeff · Fort Worth, TXN1059LPlanes & Parts Inc · Weston, FL
Back to AD 2002-26-01