AD 2002-07-01
Registered aircraft · 3,466
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:2002-07-01')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-07-01')
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:2002-07-01') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-07-01') 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.
N4609UJerden Corp · Overland Park, KSN4610KAvag Inc · Richvale, CAN4612KChitiea Andrew D · Centennial, CON4615XWaters Aero-Marine Inc · South Thomaston, MEFirst renewal noticeN4616CSan Angelo Aero L L C · San Angelo, TXN4617CBrookhaven Corp · Buffalo, NYN4617WSavoldelli Steven · Los Angeles, CAN4620YCenturion Travel LLC · Fort Worth, TXN4621QFitzgerald Barry Eugene · Springfield, ILN4622QBas Part Sales LLC · Greeley, CON4624KHoyt Matthew P · Newport Beach, CAN4624QBowen Kennith M II Trustee · Winters, CAN4625QBank Of Utah Trustee · Salt Lake City, UTN4626KWyeth Patrick B Trustee · Chino Valley, AZN4627KIsbell Brian · Rosenberg, TXN4627QMassey Larry A · New Braunfels, TXN4629KAuburn Farms LLC · Auburn, KSN4631CGraves Martin · Odessa, TXN4634U4634u LLC · Taylor, AZN4636KAdvanced Database Designs LLC · San Ramon, CAN4637UWright Air Service Inc · Fairbanks, AKN4639QGrundmann Karl · Manassas, VAN4644UWineglass Holdings LLC · Fort Davis, TXN4648ATimms Chet D · Central City, IAN4648CMadhvani Sanjay J · Tucson, AZN4649UMy Holdings Inc · Anchorage, AKN464GSHooper Mark · Elko, NVN4651TUnited Indian Missions Inc DBA · Tucson, AZN4653Q53 Quebec LLC · El Dorado, CAN4654QStapleton Mark Christopher · Vestavia Hills, ALN4656KValley Agriculture LLC · Galt, CAN465AMN465am LLC · Hollis, NHN4660CToudouze John M · La Vernia, TXN4661ZRustair Inc · Anchorage, AKN4665CKrissman Ryan · Gallup, NMN4671KNifong Robert B · Jacksonville, FLN4672KMartin Richard E Trustee · Colorado Springs, CON4674UKlein David · Sebastopol, CAN4677QDahl Larry A · Cogswell, NDN4678QPrairie Dog Aviation LLC · Sioux Falls, SDN4679YExtreme Air LLC · Cottage Grove, WIN467PZAirline Training Professionals LLC · Wilmington, DEN4680PSchmidt Aaron B · Auburn, ALN4682QHangar 27 LLC · Bountiful, UTN4689QJohnson Tod W · Three Rivers, CAN468MSSturdivant Mike P Jr · Glendora, MSN4690UKim Hansen Co · Burley, IDN4694YKempton Chevrolet Buick Ltd · Safford, AZN4695AAgarwal Ravi · Bath, PAN46CSPlane Fun Inc Tr Trustee · Snellville, GA
Back to AD 2002-07-01