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.
N46418Batesquire LLC · Clanton, ALN46419Rodgers Bruce W · Ramona, CAN4641BKey James M · Hermiston, ORN4641JN4641j LLC · Mulberry, FLN4641QFitzsimons Nicholas T · Covington, LAN4641RWebb Patrick S · Chuckey, TNN46420Frontier Environmental Solutions Inc · Inyokern, CAN46423Parrish Aviation Flight Academy LLC · Southlake, TXN4642BRegister Edmond A · Tyler, TXN4642PColumbus Sign Co · Columbus, GAN4642RSkyways Group LLC · Greensboro, NCN4642UHolt John William · Tucson, AZFirst renewal noticeN4642VBolster William L · Joshua Tree, CAN4642WHash Marshall W · Crumpler, NCN4642YFriends Aviation Inc · Wilmington, DEN46430J & Dk LLC · Overland Park, KSN46433Plummer Fred C · Normal, ILN46435Hawkins County Sports Wings Inc · Kingsport, TNN46436Aero Science International LLC · Martinez, GAN46437Arizona Active Air LLC · Yuma, AZN4643BAnderson Charles D · Fairbanks, AKN46440Engelskirger Karl D · Valley City, OHN46442Lott Terence D · Florence, MSN46448Mac Air Inc · Farmington, MON46449Tilma Flying Club Inc · Moscow, IDN4644ALee Lauren M · West Greenwich, RIN4644CMassmanf Darrel F · Ogdensburg, WIN4644FBrennan Timothy R Trustee · Mount Pleasant, SCN4644JWinslow Francis E III · Raleigh, NCN4644PFennema Alan A · San Jose, CAN4644UWineglass Holdings LLC · Fort Davis, TXN4644VHendricks Trenton Q · Bow, WAN4644YState Of Montana · Helena, MTN46457Ostrowski Sven E · Mullica Hill, NJN4645BJacobs Lydia A · Lincoln, MEN4645JHitchcock Scott B · Waco, TXN4645KOrange Air Inc · Harbor City, CANon-citizen corporation, flight hours not reportedN4645RKunz Consulting Inc · Sun Prairie, WIN4645WClimb Maintain LLC · Morrisville, MON4646Bailey Christopher J · Riga, MIN46460Walter Timothy G · Farmersburg, IAN46462Cook Aviation Services LLC · Fargo, NDN4646ANorth Sixty Taildraggers LLC · Port Ludlow, WAN4646BBravo 300 LLC · Coweta, OKN4646CWilliam Michael Moody · Anchorage, AKN4646HMilton Djana · Lakewood, WAN4646JCulley Johnny C · Amarillo, TXN4646KPloense Justin M · Big Bear City, CAN4646RWarren Global LLC · Chino, CAN4646VBaran Stephen · Littlestown, PA
Back to AD 2007-04-19 R1