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.
N798BBFlyboys LLC · Mobile, ALN798CBEye See Express LLC · Scottsdale, AZN798GMJust US Pilots Inc · Clearwater, FLN798HBN798hb LLC · Blanding, UTN798JBMidwest Aircraft LLC · Olathe, KSN798RJMaklee Enterprises LLC · Taylor, TXN799CDGpa Inc Trustee · Wilmington, DEN799DGCirrus Design Corp · Duluth, MNN799EEMiller Robert D · Big Spring, TXN799ESFive Boys Flight Training LLC · Matthews, NCN799KTAdams Aviation Services Inc Trustee · Wilmington, DEN799LFSurric LLC · Shreveport, LAN799SRMontauk Rumrunners LLC · East Hampton, NYN79AHBmac3 LLC · Fairfield, CTN79ALAirtrust LLC - 19 - Series 19 Trustee · Sheridan, WYN79APHigh Tide Aviation LLC · Naples, FLN79ASPlane Fun Inc Tr Trustee · Snellville, GAN79BPOrion 207 LLC · Harpswell, MEN79CHPala Angel E · Taos, NMN79CVVne Aviation LLC · Fort Walton Beach, FLN79CWWeber Cynthia J · Dallas, TXN79DCBnb Marine LLC · Miami, FLN79DRMcneill Steve · Santa Fe, NMN79DSBonanza Air Ventures LLC · Mammoth Lakes, CAN79DVDiscovery Associates Inc · Midland, TXN79EMLone Mountain Aircraft LLC · Vandalia, OHN79FMWoods Executive Services Inc · Mineola, TXN79FWDaniel King Aviation LLC · Dover, DEN79GWEight Charlie Tango Inc · Redmond, WAN79HCBmc Group · Hawthorne, CAN79HHOverland Aviation LLC · Plymouth, MNN79MKKarger Marjorie · Graford, TXN79PPJon Gibson Co · Cameron Park, CAN79RCBach II LLC · Lafayette, LAN79RXC Howard Aviation LLC · Rock Spring, GAN79SMTurbine Services And Consulting LLC · Bedford, TXN79WJGdm Holdings LLC · Hartford City, INN79WP79wp LLC · Scott City, KSN79XCD & J Construction And Real Estate LLC · Jupiter, FLN79YF79yf LLC · Phoenix, AZN7AVPerkins Steven · Mount Juliet, TNN7CJPropart Inc · Austin, TXN7CNMentor Flight LLC · Savoy, ILN7EESeven Echo Echo LLC · Missoula, MTN7EVYellow Star Mgmt LLC · Waco, TXN7JKosco Matthew D · Munster, INN7JNB & K Steel & Supply Inc · Ogden, UTN7LTRobertson Cameron Lee · Las Vegas, NVN7LVBas Part Sales LLC · Greeley, CON7MFBarger Christopher H Trustee · Mesa, AZ
Back to AD 2012-10-13