AD 2012-03-06
Registered aircraft · 69,559
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-03-06')
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-03-06')
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-03-06') 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-03-06') 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.
N1019CHunter James A · Elizabeth City, NCN1019JPeterson George D · Key West, FLN1019KPreferred Flight Management LLC · Goshen, INN1019PBoondocks Solutions LLC · Tomball, TXN1019ZJb Air LLC · Lindsay, OKN101AFState Of Louisiana · Baton Rouge, LAN101AMLehs Kent · Grimes, IAN101AXFogg Britt · Springdale, ARN101BACanty John Martin III · Buffalo, NYN101BBPolson Taylor M · Killeen, TXN101BEOne Bravo Echo LLC · Fernandina Beach, FLN101BHMpdkm Inc · Las Vegas, NVN101BJBlanchfield George Trustee · Yelm, WAN101BMTurk Mike · Pinehurst, TXN101BYRegistered aircraftN101CDCharlie Delta Aviation LLC · Marietta, GAN101CEDurocher Alain P · Long Beach, CAN101CMKuhns Robert M · Wichita, KSN101CWAtlanta Technical College · Atlanta, GAN101DBGildardo F Bravo · Mission, TXN101DKTremper John D · Newton, NJN101DMClunan John S · Chocorua, NHN101DRShaheen Louis · Austin, TXN101DTCristal Air Inc · Wilmington, DEN101DWInternational Air Services Inc Trustee · Carson City, NVN101DXPatierno David M · Templeton, CAN101DYDyess Investments LLC · Bassfield, MSN101ECAtkinson Justin Shane · Fairbanks, AKN101EEAlaskan Aerial Photography LLC · Anchorage, AKN101EPHoelscher Carl D · Garden City, TXN101EXMeyer Chad A · Whittemore, IAN101FKSouthern Aircraft Consultancy Inc Trustee · Casper, WYN101FRFoxfly LLC · Red Bank, NJN101GD101 Gd Corp · Miami, FLN101GEInternational Air Services Inc Trustee · Carson City, NVN101GKCramer Keith B · Paso Robles, CAN101GLAssociated Aircraft LLC · San Diego, CAN101GWPlan B Air LLC · Lago Vista, TXN101HHElmhurst Holdings LLC · East Rochester, NYFirst renewal noticeN101HRZia Aerospace LLC · Albuquerque, NMN101HTWilder Bart M · Maryville, TNN101HWYale Companies LLC DBA · Fishers, INN101JCCoonbottom Aviation LLC · Wilmington, DEN101JHHi-Per Aviation Inc · Arroyo Grande, CAN101JKKaras Dean · Lansing, KSN101JMSale Reported · Clay Center, KSSale reported, pending cancellationN101JPKrouse Donald E · Weaverville, CAN101JRSouthern Aircraft Consultancy Inc Trustee · Casper, WYN101KGQualitair LLC Trustee · MichelstadtN101LAJaguar Aviation LLC · Hillsboro, OR
Back to AD 2012-03-06