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.
N5461Lb Flying Aces LLC · Wilmington, DEN5464VLivingood Richard A · Tucson, AZN5467APiedmont Air Services LLC · Helena, MTN5469XTechaero 210 LLC · Healdsburg, CAN546CDScalini Fernando A · Huntington Beach, CAN546DMMorgan Aviation LLC · Dover, DEN546ESBurgess James R · Cave Creek, AZN546KMAero Montana LLC · Greensboro, GAN546PAJnh Properties Aviation LLC · Morganton, NCN547CHoch Jeffrey · Seattle, WAN547DTMcb Family Aviation LLC · Boca Raton, FLN547EMWolcott John · Peoria, AZN547SMTrinity Aviation LLC · Rome, GAN547TJTj Flying Adventures LLC · Port Orange, FLN5482CSantiago Robert S · Torrance, CAN5484JCaba Joseph · Covington, LAN548CPF Partnoy Inc · San Diego, CAN548EBRomeo Charlie Aircraft Partners LLC · North Little Rock, ARN548GAHyannis Air Service Inc · Hyannis, MAN548RESabair LLC · Clinton, PAN5490AN5490a LLC · Rutherfordton, NCN5495VPhillips Ruffin P Jr · Lexington, NCN549CDValiair Limited Co Trustee · Casper, WYN549SRPlane Fun Flying Club · Vancouver, WAN54AKGreat Planes Reproductive Centers Pa · Circle Pines, MNN54CCScythe & Spade Co · Grand View, IDN54DFSkywave Associates LLC · Spirit Lake, IAN54DTBell Air LLC · Valdosta, GAN54FMAetherion LLC · Miami, FLN54JNDlz Aviation LLC · Ostrander, OHN54JQRegistered aircraftN-number assigned (import), not yet registeredN54KMFredriksson Conny · Prospect, KYN54KSParia Aviation LLC · Saratoga, CAN54KYGael Aviation Inc · West Harrison, NYN54LGSynergy Wellness Group Inc · Bakersfield, CAN54LWDogtown Aviation LLC · Teton Village, WYN54LXRegistered aircraftN54PFSilverado Land Management LLC · Sparks, NVN54PSAustin Bill DBA · Sparta, TNN54SXIfr Capital Leasing LLC · Miami, FLN54TBTango Bravo LLC · Ann Arbor, MIN54VL4791 Capital Holdings LLC · Austin, TXN54WFMajmudar Krupal · Flemington, NJN54WMNemensky Jack · Southborough, MAN54YZPalmquist Gustuf · Memphis, TNN550ACCrawford Alan R · Buchanan Dam, TXN550AFAtm One Inc · Tulsa, OKN550AWWerback Andrew R · Sebastopol, CAN550BMarchetti 211 LLC · Helena, MTN550BNAllen Anne · Huntsville, TX
Back to AD 2012-10-13