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.
N4387DTravel Direct LLC · Montevideo, MNN4388MMalibu 88mike LLC · Duncanville, TXN438APWhiskey 340 LLC · Tucson, AZN438CDSquibb Daniel · Xenia, OHN438PCJaml Aviation LLC · Happy Valley, ORN438SR10sm Clr LLC · Oklahoma City, OKN43911Scud Runner LLC · Cape Coral, FLN4391EN4391e LLC · Scottsdale, AZN439NKSt Louis Aircraft Partners LLC · Saint Louis, MON439SFCarter Randy C · Poway, CAN43CPMountain View Industries LLC · Missoula, MTN43DAAero Management Holdings LLC · Hot Springs, ARN43FMBaseline Digital Inc · Satellite Beach, FLN43GWAero Development LLC · Mesa, AZN43HWPiper Nicholas W · Nanjemoy, MDN43KMSns Real Estate LLC · Portland, ORN43KNSkyforge Holdings LLC · Asheville, NCN43KYPinto Carlos Eduardo · Tucson, AZN43LDIrongate Aviation LLC · Raymond, NHN43LP430lp LLC · Marlow, OKN43MEEvans Matthew B · Granbury, TXN43MRFlight Contract Services Inc · Las Vegas, NVN43QCAviation LLC · Kalispell, MTN43TMMkt Development LLC · Venedocia, OHN43WCcp Capital Holdings LLC · Newark, DEN4402JBruton Paul · El Campo, TXN440CDN440cd LLC · Williamsburg, VAN4414RKirk Ledoux · Stanwood, WAN441BEDriftwood Aviation LLC · Northport, MIN441CFDelcardayre J Sid · Richmond, VAN441FPHumphrey Marlon · Birmingham, ALN441GWEugetech LLC · Bettendorf, IAN441TPUnited Contractors Inc · Costa Mesa, CAN441TTSunbird Airlines Inc · San Juan, PRN441WPAero Holdings LLC · Williamston, SCN4421RJ & B Aircraft Leasing LLC · Lufkin, TXN4422NValiair Lc Trustee · Casper, WYN4428CPayne Jeffrey C Trustee · Stockton, CAN4429LShingebiss LLC · Independence, ORN442CCRaymond Andrew A · Crescent, IAN442EGGrotech Inc · Fresno, CAN442FMHogan Quinn H Trustee · Milwaukee, WIN442PTAutodealersonly.Com Inc · Brunswick, GAN442SJRegistered aircraftN442TTQualitair LLC Trustee · MichelstadtN4435PRbr Investments Aviation LLC · Stanley, IDN443AKBark Aviation LLC · Las Vegas, NVN443CPBank Of Utah Trustee · Salt Lake City, UTN443PFrederick Investment Corp · Raleigh, NCN443PGCirrus Design Corp · Duluth, MN
Back to AD 2012-10-13