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.
N37PMRegistered aircraftN37RAGustafson John A Trustee · Boulder City, NVN37RCCorrao Robert F Jr · Scottsdale, AZN37RDSale Reported · Mclean, VASale reportedN37RJPiasecki Richard F Trustee · Lago Vista, TXN37SJSanche Joel Jacques · MannedorfN37THUnlimited Boat Sales Inc · Page, AZN37TMBossman Cirrus LLC · Uvalde, TXN37TSN332tt LLC · Happy Valley, ORN37UJet Set Aircraft Inc · Van Nuys, CAN37VMVictory Maximus LLC · Dublin, OHN3800PRem Real Estate Investments LLC · Longview, TXN3801CDanuser Aviation LLC · Fulton, MON3802NDiehl Donald L · Garden City, KSN38040Mosier Daniel J · Tucson, AZN38049Moore Aviation Services LLC · San Antonio, TXN3804MGlenmont Air LLC · Strasburg, VAN3807TAmbrose Construction Ltd · Corpus Christi, TXN3807XAlpha Bravo Lima LLC · Covington, TNN38082Pope Bill F · Prescott Valley, AZN380ASHacksaw Aviation LLC · Stamford, CTN380BWKbns Aviation LLC · Morgan Hill, CAN380CDTomlinson Consulting LLC · Columbia, MDN380CPBrady Craig · Mountain Brook, ALN380MMFolk Daniel H · Urbana, ILN380SRRegistration Pending · Casper, WYRegistration pendingN3810CBlake Thomas C · Vero Beach, FLN3813QBemowski Paul · Madison, WIN3817MGulf Skies LLC · Kalispell, MTN381BS381bs LLC · Fresno, CAN381CDN381cd Aviation LLC · Ventura, CAN381DSFlightpath Investments LLC · Ottumwa, IAN381LMorgan Fred M · Onancock, VAN381SWScorpion Oil & Gas LLC · Stafford, TXN381TCShumate Frank T · Rockport, TXN3820LFly A Twin LLC · Kirkland, WAN3822KPerry Park Investments Inc · Larkspur, CON3823AAndy Downs LLC · Langdon, NDN3829PRalphs Thomas A · Solana Beach, CAN382CDLakeview Aviation LLC · Middletown, DEN382CRSkyport Aviation LLC · Oxford, MIN382DEMpt LLC · Tulsa, OKN382DJTimm David M · Napa, CAN382SRJernigan Raymond James · Scotts Valley, CAN3839RChad Gunter Enterprises LLC · Albany, GAN3839SBailey Glenn K · Englewood, CON383APNavion Cca LLC · Marina Del Rey, CAN383BSky West Aviation Inc Trustee · Albuquerque, NMN383CDAmsam Transport LLC · Mustang, OKN383CPVanclef Financial Group Inc · San Luis Obispo, CA
Back to AD 2012-10-13