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.
N828PWSnowball Aviation LLC · Houston, TXN828PZEzsp Capital Holdings LLC · Corona Del Mar, CAN828RJNielsen Ron E · Lindon, UTN828RPUnique Aviation LLC · Charleston, ILN828RRNorthern Lights Sc LLC · Wilmington, DEN828SBEa Aircraft Lease LLC · Dayton, MNN828SJXonk Holdings LLC · Fort Dodge, IAN828TMTaylor Aero LLC · Lewes, DEN828TTLoud LLC · Carthage, NCN828TXGoebel Construction LLC · San Antonio, TXN828VTParque Colina LLC · San Antonio, TXN828ZZFuture Flight LLC · Billings, MTN8290EWb Aviation LLC · Belmont, MIN8290ULets Fly LLC · Fortson, GAN8292MAircraft Guaranty Corp Trustee · Oklahoma City, OKN8293MMaffett Properties LLC · Dublin, GAN8293QBaker Marianne J · Raeford, NCN8296LRoth Vicki B · Bristow, OKN8296RPowell Franklin Travis · Lone Pine, CAN8296UFritzinger Mark Thomas · Goldsboro, NCN8297ABonanza A36 LLC · Cedar Rapids, IAN8299DB K A Air LLC · Kennett, MON8299WKj 422 LLC · Augusta, GAN8299ZCoachair Inc · Groveland, CAN829BAAdaptive Resources Inc · Fort Morgan, CON829BTEichstaedt Alessandro · Denver, CON829CFKendrick Consulting LLC · Hayden, IDN829CGRegistered aircraftN829CN3771r LLC · Lockport, NYN829DXuno Group LLC · Fort Lauderdale, FLN829DMValiair Lc Trustee · Casper, WYN829DTMomentum Aviation LLC · Bogart, GAN829HSAero Systems Design Group LLC · North Reading, MAN829PKMainstay Distributing LLC · Norwalk, WIN829RRaby Ron A · Portsmouth, NHN829RC829rc LLC · Lewes, DEN829UMSlate Ridge LLC · Alpine, WYN829WBlue Sky Transport LLC · Deland, FLN82AUPappy John E · Keller, TXN82AWQualitair LLC Trustee · MichelstadtN82BVetted Air LLC · Saint Petersburg, FLN82CKBloxham Thomas L · Pleasant Hill, CAN82DHBonlori Aviation LLC · Ruston, LAN82DPCirrus Design Corp · Duluth, MNN82DSSiekmann David G · Scottsdale, AZN82ESkymaster Mods & Parts LLC · Castalian Springs, TNN82FGTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN82GBAmerican Aviation Inc · Page, AZN82JRRoss Jerry Dean · Springfield, MON82LYFly Bye Holdings LLC · Dallas, TX
Back to AD 2012-10-13