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.
N2744XAccelerated Slipstream LLC · Livermore, CAN2744YDe Vuyst Richard C · Pampa, TXN27457Felix Margarita G · Nogales, AZN2745FAlexander Production Co · San Antonio, TXN2745GKj3 Air LLC · Mitchell, SDN274ASCcp Aviation LLC · Union Grove, NCN274DCMaggie 288 LLC · Quincy, WAN274EBBakhit Aviation LLC · Roanoke, VAN274EFFour Forces Aviation LLC · Princeton, NJN274EJJab23 LLC · Grand Rapids, MIN274HAPacific Rain Inc · Arroyo Grande, CAN274MRAero Systems Inc · Broomfield, CON274MTWos Holdings Vi LLC · Belgrade, MTN274SLHowden Frederick M · Coronado, CAN274SRTn Sr22 LLC · Farragut, TNN275ABR2box LLC · Dover, DEN275RCGianopoulous William · Lawrence, MAFirst renewal noticeN275TCirrusly Flying LLC · Missoula, MTN275TCQualitair LLC Trustee · MichelstadtN2763Valiair Lc Trustee · Casper, WYN276CDGandia Justin Kidd · Chicago, ILN276CMTwo Fly Guys LLC · Orlando, FLN276CPRothlisberger Ben · Farmington, MON276GEMaricorp U S LLC · Shell Knob, MON276GSSampson Gabriel · Huntsville, UTN277CDSkywalker Stratos LLC · Palo Alto, CAN277CMMirasoles Produce USA LLC · Palmurst, TXN277CTRoss Peter W Trustee · Lufkin, TXN277JDMeadows Construction Corp · Fort Smith, ARN277LMRegistration Pending · Bend, ORRegistration pending, pending cancellationN277RRossignoli Holdings LLC · Atlanta, GAN277WWLee Aviation Co LLC · Pensacola, FLN277XSalopek Rett · Las Cruces, NMN2786SCake Aviation LLC · Mcgregor, MNN278AZLef278az LLC · San Angelo, TXN278CDCirrus Aviators LLC · Elm Grove, WIN278DBCt42 LLC · New York, NYN278EHE&H Aviation LLC · Kennesaw, GAN278GZNichols Industrial Construction Co Inc · Birmingham, ALN278JAAerownership North American Services Inc Trustee · Wilmington, DEN278PBP21000318 Inc Trustee · Wilmington, DEN278SREllsworth Farm LLC · Kingsbury, NYN278TCLittle Bird Air LLC · Wenatchee, WAN278WDSnk LLC · Reisterstown, MDN279CPBarnard Henry H III · Albany, GAN279CWPapas Plane LLC · Ashland, NEN279JLJml Aviation LLC · Berwyn, PAN279JPTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN279MTGmcm Aviation LLC · Central, SCN279PSCirrus Design Corp · Duluth, MN
Back to AD 2012-10-13