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.
N4673BRacoon Aviation LLC · San Antonio, TXN4673FCody Richard A · Mclean, VAN4673NSimla Properties LLC · Casa Grande, AZN4673RBall Dontel J · Tacoma, WAN4673SGear Up Aviation LLC · Yukon, OKN4673UStephl Chris L · Soldotna, AKN46742Barlet Richard D · Carthage, MON46743Longino Thomas G · Celeste, TXN46744Harrison Airplane LLC · Cynthiana, KYN46746Dunlap Gary P · Seattle, WAN4674EMilliken Bradley B · San Mateo, CAN4674MPerpetual Rkm LLC · Kalispell, MTN4674NBorderline Sky LLC · El Paso, TXN4674UKlein David · Sebastopol, CAN4675CLane Robert W · Palmer, AKN4675ERojo Aircraft LLC · Mesquite, NVN4675JRegistration Pending · Gardnerville, NVRegistration pendingN4675RLatham Cary · Hardin, KYN46760Caterinichio Gasper D · Eagle River, AKN4676BRobbins J Putnam · Valparaiso, INN4676FSt Pete Aviation Services LLC · Saint Petersburg, FLN4676PHuslig Brandon M · Carefree, AZN46775Lookner Augustus · Owls Head, MEN4677DHorton Richard F · Los Lunas, NMN4677NLps Equipment And Acquisition Co Inc · Clarksburg, TNN4677QDahl Larry A · Cogswell, NDN4677RFields Michael L · Rockwood, TNN4678AIflyjctc82 LLC · Macomb, ILN4678BKing Paul E · Albany, ORN4678DKennedy Kevin L · Moscow, IDN4678FMullett Sean · Cleveland, TNN4678KGarcia Roberto P · Spring Hill, FLFirst renewal noticeN4678PRudloff Uwe K Trustee · Lake Village, INN4678QPrairie Dog Aviation LLC · Sioux Falls, SDN4678RRegistration Pending · Vadnais Heights, MNRegistration pendingN4678TRothberg Diane Lee · Gainesville, GAN4679AFlying Bulldogs LLC · Joplin, MON4679GFlightime Inc · Elkhart, INN4679HAdams Kris · Griffin, GAN4679UNelson Ross R · Menomonie, WIN4679WBravo Whiskey LLC · Cascade, CON4679YExtreme Air LLC · Cottage Grove, WIN467AArcher Aircraft LLC · Wilmington, DEN467AAWings Over Texas Holdings LLC · Denton, TXN467AT467at LLC · Frankfort, ILN467CDStarship 1 LLC · Houston, TXN467CMIasco Flight Training Inc · Redding, CAN467DBParamont Services Inc · Newbury Park, CAN467DHLopez Floyd W · Arroyo Seco, NMN467DKRegistered aircraft
Back to AD 2007-04-19 R1