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.
N5440PWurlitzer Lindsay Pabst Trustee · Healdsburg, CAN54410Law Aircraft LLC · Oak Grove, MNN54412Flight Time Builders Inc · Memphis, TNN54413Belcher Phillip B · Claremore, OKN54414Panjab Aviation Inc · Las Vegas, NVN54416Glenn Richard L · York, PAN5441BFour One Bravo LLC · Piedmont, SCN5441HKlein Darrell J · Deland, FLN5441LTop Flight Aviation Snh LLC · Savannah, TNN5441NYanta Aircraft Holdings LLC · San Antonio, TXN5441PBellah Mark E · Alva, OKN54420Gibson Andrew P · Goleta, CAN54421Miloud Chadd · Fort Worth, TXN5442HJones Gareth B · Goldsboro, NCN5442NDeruwe Karl J · Othello, WAN5442PMountain Air Restoration · Bend, ORN5442TMckinney Christopher W · Queensbury, NYN5442UMorisseau Walner · Tampa, FLN5442WHarris Joshua J · Athens, TXN5442YGolden Eagle Outfitters Inc · Delta Junction, AKN54433Registered aircraftN54435Bond Investigations Aviation LLC · Phoenix, AZN5443PSbroglia Gregory A · Farmington Hills, MIN5443VTurk Aviation LLC · O Fallon, ILN54445Jensen Allen R · Tremonton, UTN54446Avia Flight Academy LLC · Stratford, CTN54447Soares Sergio Cardoso · Hillside, NJN54448Jupiter Flight Service And Investing LLC · Lithonia, GAN5444FAnderson Aviation LLC · Bulverde, TXN5444HIowa Lakes Community College · Estherville, IAN5444JHm Aviation LLC · Cape Fair, MON5444LBeck Michael C · Farmington, CTN54452Epling Kenny B · Mechanicsville, VAN54457Plane Sailing LLC · Lawrenceville, GAN5445BWilds Terrance L · Grand Rapids, MIN5445DLabtech Expert LLC · Waycross, GAN5445FMikeco LLC · Pine Bluff, ARN5445WIsom Colin A · Shawano, WIN54461Cline Christopher T · Dublin, OHN54462Loon Aviation LLC · Northfield, MNN54466Field George Walker DBA · Bedminster, NJN54468Legacy Training Group · Oklahoma City, OKN5446BDavis Elizabeth · Flagstaff, AZN5446GCentral Virginia Aviation Inc · North Dinwiddie, VAN5446HBlizzard William F Jr · Barboursville, WVN5446PRegistration Pending · Cypress, TXRegistration pendingN5446WSmith June Ann M · Tucson, AZN54470Barton Scott · Calhoun, GAN54471Jamerson Scott C · Charleston, WVN54473Gomez Julian E · Palo Alto, CAFirst renewal notice
Back to AD 2007-04-19 R1