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.
N2914LPanalucent LLC · Saint Petersburg, FLN2914MPannone Steven R · Palmer, AKN2914PPerreault Guy · Newbury Park, CAN2914QEast High Flying · Othello, WAN2914RLandrith Robert L · Mustang, OKN2914TTp Aviation Inc · Augusta, KSN2914YBol Aero LLC · Beverly Hills, CAN2914ZEarle Russell John · Reno, NVN29151Inland Aerial Surveys Inc · Riverside, CAN29157Midwest Aero Inc · Bay City, MIN29159Southridge Developments Inc · San Miguel, CAFirst renewal noticeN2915BRobble Group LLC · Center Valley, PAN2915CField Jeff H · Simi Valley, CAFirst renewal noticeN2915FStoffregen Thomas S · Milton, WVN2915GWalls Properties LLC · Paragould, ARN2915LZorro Stephen · Rocklin, CAN29160Felber Dave A · Florissant, MON29164Iturriria John · Kuna, IDN29168Galer Michael J Jr · Lockwood, MON2916AMetro Service Air Inc · Fairbanks, AKN2916FAndros Marketing LLC · Fort Lauderdale, FLN2916LPospisil Thomas · Rockwood, PAN2916TLewis Paul A · Spring, TXN2916WPilots Flying School LLC · Manalapan, NJN29170Kuhlmann Connor · Ada, MIN29172Reutter David C · Mount Kisco, NYN29173Aerial Transport LLC · Wilmington, DEN29176Tgr Helicopters · Fresno, CAN2917CParks Joseph S · Wilmington, NCN2917FBennett David D · Clinton, WAN2917LDobbs J S · Medford, ORN2917PRegistered aircraftN2917RCzarnecki Neil A · Racine, WIN2917ZRegistration Pending · Granby, MORegistration pendingN29181Wings Of Faith · Stevensville, MTN29186Thoroughbred LLC · Kalispell, MTN29188Rugger Investment Group LLC · Tustin, CAN2918DMelton Derrick · Midland, TXN2918EDelpenn Flyers Inc · Dover, DEN2918KHolmes Ronald W · Kent, ORN2918LHieb Jared J · Amarillo, TXN2918PLafferty Eric M · Anchorage, AKN2918RTown Thomas L · Chino Valley, AZN2918VLinse Shane G · Billings, MTN2918XFlight Leasing Corp · Wilmington, DEN2918ZLarson David R · Boerne, TXN2919CRudolph Darren M · Wasilla, AKN2919FPerez Adolfo · Conroe, TXN2919KWoodaire Ltd · Coeur D Alene, IDN2919TParsons William Tony Jr · Medina, TN
Back to AD 2007-04-19 R1