AD 2012-10-13
Registered aircraft · 13,306
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:2012-10-13')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-10-13')
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:2012-10-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-10-13') 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.
N56JTNovak Jack · Dallas, TXN56LLLegacy Leasing Group Inc · Wilmington, DEN56LRSpeed And Angels LLC · Kalispell, MTN56MAMinuteman Aviation Inc · Missoula, MTN56PEHart Everett T · Frederick, MDN56PFLucero John · Long Key, FLN56PNNorth Breakenridge Farm LLC · Burlington, WIN56RMSchulte Aviation LLC · Donnellson, IAN56RRValiair Lc Trustee · Casper, WYN56TJTrue North Aviation LLC · Leclaire, IAN56TLAviation Manpower Solutions Inc · Nashville, TNN570CDDelta Zulu Air Ventures LLC · Charleston, SCN570CPAces Hangar LLC · Bentonville, ARN570RJEos Cirrus LLC · Las Vegas, NVN570TBTbbs Aviation LLC · Kirkland, WAN570TPPaul Wallner LLC · Missoula, MTN570WEStella Polaris LLC · Charlottesville, VAN571CDN&I Skies LLC · Leesburg, VAN571JCJc Aviation LLC · Smithville, TNN571SKLong Ryan S · Auburn, CAN571TARegistered aircraftN572CAValiair Lc Trustee · Casper, WYN572CDWaite Aviation LLC · Xenia, OHN572CPCots Partners LLC · Saint Augustine, FLN572CTDawson Aero LLC · Fayetteville, ARN572GTBcg Aviation LLC · Nashville, ARN573CDF R E Investments LLC · Enterprise, ALN573CPThib Rentals LLC · Huntington Beach, CAN573DSDebrey Thomas M · Hilton Head Island, SCN573JRHispania LLC · Camarillo, CAN573SRS & S Bridge Painting Inc · Kerrville, TXN573TTHansa Capital LLC · Wilmington, DEN573WBKinney Aviation LLC · Columbia, MON5743JMidwest Aerial Photography · Galloway, OHN574CDMassingale Harold L · Lenoir City, TNN574CPLaunchpad Properties LLC · Corpus Christi, TXN574CSNomic Air LLC · Vienna, VAN574HALow Approach LLC · Wilmington, NCN574KKurz Douglas · Houston, TXN574RKHorn Aviation LLC · Hartland, WIFirst renewal noticeN574RMCardinal Enterprises LLC · Denver, CON574SBristol Aircraft Leasing LLC · Willoughby, OHN574TBTransportation Air Services LLC · Fair Oaks Ranch, TXN574WDLathrop Frederic W · Dayton, OHN5754MJ & A Aviation LLC · Danvers, MAN5757CRoberts Justin · Livingston, MTN575CDG2 Aero LLC · Chattanooga, TNN575CPHka Flying Club LLC · Hoover, ALN575GWNeuse Aviation LLC · Smithfield, NCN575JPJpr Aviation LLC · Hillsdale, IN
Back to AD 2012-10-13