AD 2007-04-19 R1
Registered aircraft · 108,434
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:2007-04-19-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2007-04-19-R1')
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:2007-04-19-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2007-04-19-R1') 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.
N325SMPurple Raven Partners LLC · Lexington, KYN325SRFingerhut Steven · Cross Plains, TXN325SWSheroyair LLC · Sarasota, FLN325TCTexas State Technical College · Waco, TXN325TROtter Aviation · Warrensburg, MON325WVEphofen Jack O · Allegan, MIN325XJahn Paul B · Nevis, MNN325XSBurns Craft LLC · Wilmington, DEN3260Hennessee Thomas T · Morganton, NCN3260FGilbert Aviation Inc · Wilmington, DEN3260SAbner Aviation LLC · Advance, NCN3260YOneal Gary · Springdale, ARN32610Ambrose Air LLC · Raleigh, NCN32613Gray Matthew C · Enterprise, ALN32618United Towing & Transport Inc · Burbank, CAN3261CHeyman Steven · San Mateo, CAN3261DCastorina John Salvatore · Anthem, AZN3261MDyas Chris · Fairhope, ALN3261SBig Island Gravity LLC · Kapaau, HIN3261WParish Ora Nichols · Martinez, GAN32622Region Flyers LLC · Valparaiso, INN32623Five Sides Racing LLC · Fallbrook, CAN32627Joyner Hudson Ellis · Memphis, TNN3262FCm&K Enterprises Inc · Brandon, MSN3262SIlair LLC · Manassas, VAN3262XDns Aviation LLC · Fulton, CAN32631Grewell Dean R · Waukee, IAN3263FVelazquez Carlos A · Lexington Park, MDN3263PSalazar Ralph T Jr · Leesville, LAN3263SBynum Albert L · Gadsden, ALN3263ZCaldwell Jacob A · Soldotna, AKN32645Taylor Trent & Haugan Inc · Santa Barbara, CAN32646Russell Thomas Carl · Beverly Hills, FLN32649Pensinger Chris · Saint Paul, MNFirst renewal noticeN3264FWhite Sawyer A · Longmont, CON3264QWilton William H · Kailua Kona, HIN3264TVan Iderstyne Richard D · Jekyll Island, GAN3264UTri-B Air LLC · Plano, ILFirst renewal noticeN3264XDesert Cat Aviation LLC · Tempe, AZN32653Emerald Flyers LLC · Everett, WAN32659Allen Aviation LLC · Mansfield, MAN3265AMustang Sally Aviation LLC · Camden, SCN3265DMiller Matthew S · Washougal, WAN3265ETa Brand LLC · Middletown, DEN3265FOsborne Allen Wright · Waxhaw, NCN3265SZehntner David R · Labelle, FLN3265UPreissler Daniel E · Giltner, NEN32662Murukas Nicholas · Bourbonnais, ILN32665White Richard L Trustee · Los Altos, CAN3266EN3266e LLC · Homestead, FL
Back to AD 2007-04-19 R1