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.
N32700Mob Aviation USA LLC · Auburndale, FLN32701Rees Truck & Trailer Inc · Fort Dodge, IAN32702Eagle Air Group LLC · Stafford, VAN32703Venture West LLC · Mesa, AZN32704Hobson Martin G · Loomis, CAN3270DMcbride Robert W Jr · Cedar Park, TXN3270JBerry Matthew G · Creedmoor, NCN3270RMotorman Of America Corp · Wilmington, DEN3270UScott Brian W · Sagle, IDN3270ZWhite Glenn A · Timber, ORN32711Three Rivers Aero LLC · Three Rivers, MIN32712Piper712 LLC · Saint Petersburg, FLN32713Bleese Hubert A · Enderlin, NDN32714Meringer Ronald Eduardo · Phoenix, AZN3271GPettit James P · Newport, VAN3271KCameron Reginald B · Cumberland, MEN3271UDallas Avionics Inc · Dallas, TXN3271XCoastal Defense Inc · Mill Hall, PAN3271YWoodbury Ivan D · Bowling Green, OHN3271ZModra Anthony K · Fredonia, WIN32727Denton Christopher G · Youngsville, NCN3272FCarroll Daniel T · Holbrook, AZN3272TSonoras John G Jr · Newport, MIN3272VWooldridge Homes LLC · New Haven, KYN3272WTownsend Douglas W · Charlotte, NCN3272YOlsen Chris M · Othello, WAN32731Reels Up LLC · Middletown, DEN32735Hukle Grant L · Mantachie, MSN32739Beneke Mark N · Bushton, KSN3273EAnderson Thomas J · Big Bear City, CAN3273FRydeen Carl Edward · Little Falls, MNN3273MLindeen Michael · Anchorage, AKN3273SHepfer John E DBA · Midland, TXN3273ZWeber John D · Shelbyville, ILN32744Arndt Douglas E · Marion, WIN32747Aaof Investments LLC · Fort Mc Coy, FLN32749Ryszka Aviation LLC · Heber City, UTN3274DMcroberts David M · Washoe, NVN3274EBitzer John · Cologne, MNN3274RBurton Re Holdings LLC · Mustang, OKN3274TRinkle Michael G · Sussex, NJN3274XBoyer Dennis A · Harvest, ALN3274ZHeide Jeffrey J · Kenosha, WIN3275CMoore Hazel Grace · Boise, IDN3275DCrystoff James J · Kodiak, AKN3275FThree Chopt Flying Club · Charlottesville, VAN32761Harding Antony · Rittman, OHN32762Keyes William H · Englewood, TNN32767James Stanley C · Palmer, AKN32769Sarasota Aero Club LLC · Venice, FL
Back to AD 2007-04-19 R1